Northwind Test with Yukon

Current Product List View

Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks


Columns

NameTypeLengthIsNullableCollation
ProductIDint4 
ProductNamenvarchar80SQL_Latin1_General_CP1_CI_AS 
ProductNamesysname80SQL_Latin1_General_CP1_CI_AS 

View Definition

create view "Current Product List" AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))
--ORDER BY Product_List.ProductName